TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark
نویسندگان
چکیده
The TPC-D benchmark was developed almost 20 years ago, and even though its current existence as TPC-H could be considered superseded by TPC-DS, one can still learn from it. We focus on the technical level, summarizing the challenges posed by the TPC-H workload as we now understand them, which we call “choke points”. We identify 28 different such choke points, grouped into six categories: Aggregation Performance, Join Performance, Data Access Locality, Expression Calculation, Correlated Subqueries and Parallel Execution. On the meta-level, we make the point that the rich set of choke-points found in TPC-H sets an example on how to design future DBMS benchmarks.
منابع مشابه
Lessons Learned from the Lorestan Flood Crisis: Relief Experience in Pol-e-Dokhtar Flood
This article has no abstract.
متن کاملImportant Lessons Learned From Nearly a Half-Century of Orthopedic Practice
“Those who cannot remember the past are condemned to repeat it” [1]. The famous quote from Hispanic American philosopher George Santayana reminds us of the critical importance of constantly reflecting on the most important lessons garnered from both our own personal experiences and those of our peers. In 49 years of academic orthopedic practice, I have frequently reflected on the most important...
متن کاملHospital Management in Infectious Disease Outbreak: Lessons Learned from COVID-19
Background: Biological events including epidemics, pandemics, emerging, and reemerging infectious diseases have significant adverse consequences on health. The hospitals have a major role in the management of outbreaks and mitigation of effects. During pandemics health systems especially, hospitals may be affected. Methods: Therefore, the current study aimed to collect and analyze lessons lea...
متن کاملFactors Affecting Medication Errors from Nurses' Perspective: Lessons Learned
Introduction: Medical errors are among the most threatening faults against patient’s safety in all countries. The most frequent medical errors are medication errors which can lead to serious effects and even death in patients. Therefore, this study aimed to explain factors affecting medication eroors from the viewpoints of nurses in order to present strategies to reduce these errors. Methods:...
متن کاملRegionalization of the Iowa State University Extension System: Lessons Learned by Key Administrators
The cyclical economic downturn in the United States has forced many Extension administrators to rethink and adjust services and programming. The Cooperative Extension System (CES), the organization primarily responsible for governmental Extension work in the United States, at Iowa State University responded to this economic downturn by restructuring its organization from county based to a regio...
متن کامل